Problem Note 61438: Creating a Netezza view fails with “ERROR: The create view statement cannot be executed directly against the database because of errors”
 |  |  |  |
SAS® Data Integration Studio can be used to model processes that create Netezza tables and then create Netezza views that reference these tables. You might encounter an issue in which the Netezza view creation code fails with this error:
ERROR: The create view statement cannot be executed directly against the database because of errors.
You might encounter this issue when you perform steps similar to the following:
- Run the SAS Data Integration job that creates the Netezza table and then creates a Netezza view of that same table.
- Modify the SAS Data Integration job and change one of the column names in the Netezza table and view.
- Attempt to run the job again. The Netezza table is deleted and re-created, but the Netezza view creation code fails with the error mentioned above.
To circumvent the issue, use SQL procedure pass-through code similar to the following to delete the Netezza view:
proc sql;
connect to netezza (database=nz_database server=nz_server authdomain="NetezzaAuth" );
execute (drop view nz_view_name) by netezza;
disconnect from netezza;
quit;
connect to netezza (database=nz_database server=nz_server authdomain="NetezzaAuth" );
execute (drop view nz_view_name) by netezza;
disconnect from netezza;
quit;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Netezza | Microsoft® Windows® for x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 9.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 R2 | 9.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 for x64 | 9.41 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Linux for x64 | 9.41 | 9.43 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-12-12 14:51:40 |
| Date Created: | 2017-11-20 12:23:36 |